Need to undersatnd the qlik formula

[kumarleau]

Hi All,

I am new to Qlik. I would like to understand stand below formula

Formula1:   num(count(distinct{<[Usage] = {">=1"}>}[ID: Conversation])))

Formula2: num(count(distinct{<[Usage] = {"1"}>}[ID: Conversation]))

Usage column Usage which is a varchar data type have data like below

1

2

3

4

complete

progress

But using the above 2 formula's I need to calculate as Formula/Formula2.

SO my question is can we get >1 result from varchar column

Regards,

Kumar

[Brett_Bleess]

The best thing for starters would be the following links, they should provide assistance:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

I am assuming the set analysis is the part that is confusing, hopefully I got that correct and hopefully the links will help get you on the right track as far as what the setup of the set analysis is doing in the expression.

Regards,
Brett

[Kushal_Chawda]

@kumarleau  Yes. You can get it >1 count which will ignore the text values. You can try it your self by creating simple inline table.