Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
johnan
Creator III
Creator III

3 expressions

Hi all,

I have 3 expressions

1 Normal Users
2 Advance Users
3 Both Normal And Advance Users.

I want to calculate Nr 1 and 2 and 3, and i do.
Example:

1, 34
2, 45
3, 65

If you are in category 1 you have taken 1 licens
If you are in category 2 you have take 1 licens
But if you are in catecory 3 you have taken 1 from category 1 and category 2

Can i calculate this in QV?

3 Replies
Not applicable

I cant understand you... can you publish a script with a example? Thanks.

johnan
Creator III
Creator III
Author

Yes 🙂

Not applicable

In your example, can't you check with an "IF" if a certain criteria is fullfilled? (Or use Flag or create a counter during load time?

For expression 1 in your file
Count(if(Type=1 or Type=12,Type))

BR
Hans